===Database morgansketo

== Table structure for table categories

|------
|Column|Type|Null|Default
|------
|//**categoryID**//|int|No|
|name|varchar(50)|No|
|description|varchar(50)|Yes|NULL
== Dumping data for table categories

|9|MainCourses|Healthy-hearty main courses for low carb keto diet
|10|Snacks|Keto snacks and sides
|11|Soups|Soups for your soul
|12|Dessert|Low-carb keto desserts
== Table structure for table contact_messages

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|name|varchar(100)|No|
|email|varchar(100)|No|
|phone|varchar(30)|Yes|NULL
|message|text|No|
|created_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table contact_messages

|1|Morgan Dora|renee.sami.mail@gmail.com|NULL|mammamia donna Klara, Graet Scott|2025-12-10 03:30:39
|2|Miss Morgan Dora|Phd.doramorgan@gmail.com|NULL|TEST MESSAGE SQL INJECTION* TEST* TEST* MEASURES|2025-12-21 23:05:22
== Table structure for table customers

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|name|varchar(100)|No|
|email|varchar(100)|No|
|phone|varchar(30)|Yes|NULL
|address|varchar(255)|Yes|NULL
|created_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table customers

|1|Alice Morgan|alice@example.com|1234567890|123 Keto Street, London|2025-12-02 16:42:23
|2|Bob Smith|bob@example.com|0987654321|45 Healthy Ave, London|2025-12-02 16:42:23
|3|Charlie Brown|charlie@example.com|NULL|78 Lowcarb Road, London|2025-12-02 16:42:23
|4|Morgan Dora|phd.doramorgan@gmail.com|0789456523|8 Whitehawk road Brighton|2025-12-02 22:43:28
|5|Ottavio Fernandez|ottav@yahoo.com|54654654|4 Straight Road, Birmingham, BR56TY|2025-12-09 21:58:55
== Table structure for table gallery

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|title|varchar(100)|Yes|NULL
|image_url|varchar(255)|No|
|description|text|Yes|NULL
|created_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table gallery

|1|Keto Bread|images/10.jpg|Healthy low carb bread made of almond flour|2025-12-03 06:04:25
|2|Vanilla Cheesecake|images/20.jpg|No bake cheesecake  with almond flour base and tasty creamy topping|2025-12-03 06:04:25
|3|Greek Chicken Skewers Deluxe|images/21.jpg|Greek-style skewers with low-carb flatbread, garlic-dill crème fraîche, and fresh herbs|2025-12-03 06:04:25
|4|Lamb Stew|images/22.jpg|Slow cooked high protein lamb stew|2025-12-03 06:04:25
|5|Chicken Gyros plate|images/23.jpg|Greek recipe Gyros with low Carb flat bread an Tzatziki|2025-12-03 06:04:25
|7|Wide variety ingredients|images/2.jpg|Delicious Keto friendly meals and snacks|2025-12-04 11:17:46
== Table structure for table menu_items

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|name|varchar(100)|No|
|description|text|Yes|NULL
|price|decimal(6,2)|No|
|categoryID|int|Yes|NULL
|image_url|varchar(255)|Yes|NULL
|availability|tinyint(1)|Yes|1
== Dumping data for table menu_items

|2|New York Keto Cheesecake|Cake base made of low carb almond flour*|5.99|12|images/chck.jpg|1
|111|Greek Chicken Skewers Deluxe|Greek-style skewers with low-carb flatbread, garlic-dill crème fraîche, and fresh herbs|7.00|9|images/21.jpg|1
|120|Hungarian Lamb Stew|Slow cooked high protein lamb stew, in Hungarian style|7.99|9|images/22.jpg|1
|134|Chicken Gyros plate|Greek recipe Gyros with low Carb flat bread an Tzatziki|6.90|9|images/23.jpg|1
|200|Zucchini fritters|Low carb, high protein snack made of Zucchini, eggs, almond flour, seasonings, cottage cheese|4.99|10|images/333.jpg|1
|300|Keto Chicken Soup|Soup with chicken and cauliflower rice|4.99|11|images/40.jpg|1
|998|Paprika Beef Stew|Slow cooked hungarian paprika-style stew|7.90|9|images/998.jpg |1
|999|Chicken Kiev|HotPocket w cheesy mustard garlic butter|9.70|9|images/P.jpg |1
|7777|Chocolate mousse|Keto-friendly mousse with keto whipped cream|5.90|12|images/7777.jpg|1
== Table structure for table orders

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|customer_name|varchar(255)|Yes|NULL
|customer_email|varchar(255)|Yes|NULL
|customer_phone|varchar(50)|Yes|NULL
|customer_address|text|Yes|NULL
|order_details|text|Yes|NULL
|status|varchar(50)|Yes|Pending
|created_at|datetime|Yes|CURRENT_TIMESTAMP
== Dumping data for table orders

|2|Morgan Dora|renee.sami.mail@gmail.com|07383837292|Flat E
23 Oliver Grove|;l&#039;kno[i&#039;|Cancelled|2025-12-05 06:53:40
|3|Morgan Dora|Info.instructor@keikenkarate.co.uk|07863196932|FLAT 8. KUBIC APARTMENTS
Whitehawk Road|1 cheescake 
2 chicken skewers
delivery please|Completed|2025-12-05 17:59:02
|4|Morgan Dora|Info.instructor@keikenkarate.co.uk|07863196932|FLAT 8. KUBIC APARTMENTS
Whitehawk Road|eher|Completed|2025-12-05 18:00:37
|5|Miss MORGAN DORA|Phd.doramorgan@gmail.com|07863196932|15 Rugby Road
bristol gardens|1 gyros|Completed|2025-12-05 18:05:17
|6|Morgan Dora|Info.instructor@keikenkarate.co.uk|07863196932|FLAT 8. KUBIC APARTMENTS
Whitehawk Road|re5y|Cancelled|2025-12-05 18:12:32
|7|Morgan Dora|2327894@student.uwtsd.ac.uk|07863196932|2 kubic apartments, whitehawk road
Whitehawk road|gvhk|Completed|2025-12-05 18:43:15
|8|morgan|2327894@student.uwtsd.ac.uk|07863196932|15 Rugby Court
Bristol Gardens|nckhg|Completed|2025-12-05 18:55:03
|9|Morgan Dora|Info.instructor@keikenkarate.co.uk|07863196932|FLAT 8. KUBIC APARTMENTS
Whitehawk Road|ggjfgj|Completed|2025-12-05 19:22:06
|10|Miss Morgan Dora|Phd.doramorgan@gmail.com|07863196932|Flat 8 Kubic Apts Whitehawk Road
Whitehawk road|hgkg|Completed|2025-12-05 19:34:21
|11|Miss MORGAN DORA|Phd.doramorgan@gmail.com|07863196932|15 Rugby Road
bristol gardens|;lpoi[oi[|Completed|2025-12-05 20:22:56
== Table structure for table pages

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|title|varchar(100)|No|
|**slug**|varchar(50)|No|
|content|text|Yes|NULL
|updated_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table pages

|1|Morgans&#039;s Keto Restaurant Sweet Home|home| Enjoy delicious low-carb meals |2025-12-05 00:49:45
|2|About|about|&lt;p&gt;The Story of Morgans Keto&lt;/p&gt;
&lt;p&gt;In 1996, Morgan Dora graduated from the Hungarian Culinary Academy, gaining extensive experience with cuisines from around the world.&lt;/p&gt;
&lt;p&gt;Driven by a passion not only for creating extraordinary dishes but also for understanding why people gain weight, she began conducting scientific research into food ingredients.&lt;/p&gt;
&lt;p&gt;Her in-depth knowledge of nutrition and culinary science enabled her to develop a unique method that allows her clients to enjoy delicious, wholesome meals without compromising their health or weight goals.&lt;/p&gt;
&lt;p&gt;She decided to share her skills and knowledge and founded Morgan&#039;s Keto Restaurant.&lt;/p&gt;
&lt;p&gt;&lt;b&gt;&lt;i&gt;Philosophy is simple yet powerful: &quot;Feeding our customers in a consciously healthy way with fullness, deep down on the cellular level.&quot;&lt;/i&gt;&lt;/b&gt;&lt;/p&gt;
&lt;p&gt;Our Kitchens are a haven of quality ingredients, free from sugar, high-carb flours, or any unhealthy additives—a true culinary garden where flavour and wellness meet.&lt;/p&gt;
&lt;p&gt;Today, Morgan&#039;s Keto Restaurant demonstrates that losing weight while enjoying incredible food is not only possible but enjoyable. While many restaurants serve heavy, high-sugar dishes that contribute to obesity, diabetes, and other health issues, Morgan&#039;s Keto Head Chefs has redefined modern dining by combining culinary excellence with scientific insight.&lt;/p&gt;
&lt;p&gt;In addition to her culinary mastery, Morgan brings expertise in food chemistry and even quantum physics, ensuring her approach to cooking and nutrition is as innovative as it is effective.&lt;/p&gt;|2025-12-04 18:59:57
|3|Menu|menu|Check out our wide variety of keto-friendly dishes.|2025-12-02 22:47:48
|4|Contact|contact|Get in touch with us via email or phone.|2025-12-02 22:47:48
|12|Food Menu|food-menu|Explore our delicious keto-friendly food menu.|2025-12-04 05:59:15
|13|Gallery|gallery|Check out our gallery of dishes.|2025-12-04 05:59:15
|14|Order|order|Place your order online easily.|2025-12-04 05:59:15
== Table structure for table reviews

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|menu_item_id|int|No|
|customer_id|int|Yes|NULL
|rating|tinyint|No|
|comment|text|Yes|NULL
|created_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table reviews

|1|7777|NULL|5|It was so fantastic this chocolate mousse weel done!|2025-12-09 22:26:14
|2|7777|NULL|5|It was so fantastic this chocolate mousse weel done!|2025-12-09 22:28:51
|3|2|NULL|3|five star|2025-12-09 22:29:29
|4|2|NULL|1|Absolutely amazing!|2025-12-09 22:35:52
|5|300|NULL|5|bautiful service|2025-12-10 00:59:11
|6|999|NULL|5|Very nice|2025-12-10 03:20:49
== Table structure for table settings

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|**setting_name**|varchar(100)|No|
|setting_value|text|Yes|NULL
|updated_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table settings

== Table structure for table subscribers

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|**email**|varchar(255)|No|
|subscribed_at|datetime|No|
== Dumping data for table subscribers

|1|Phd.doramorgan@gmail.com|2025-12-04 19:54:39
|2|2327894@student.uwtsd.ac.uk|2025-12-04 20:10:41
|3|renee.sami.mail@gmail.com|2025-12-04 20:17:20
|4|Info.instructor@keikenkarate.co.uk|2025-12-04 20:18:03
|5|Michaeljackson@gmail.com|2025-12-21 23:35:49
== Table structure for table users

|------
|Column|Type|Null|Default
|------
|//**id**//|int|No|
|name|varchar(100)|No|
|**email**|varchar(100)|No|
|password|varchar(255)|No|
|role|enum(&#039;admin&#039;, &#039;staff&#039;)|Yes|staff
|created_at|timestamp|Yes|CURRENT_TIMESTAMP
== Dumping data for table users

|1|Morgan Dora|phd.doramorgan@gmail.com|$2y$10$8UNrC9ZRUDSeYraLGxcJ5edLtUSCxU88a5zcnIu0.7dWczlqxJEdm|staff|2025-12-04 07:17:20
|2|Michael J. Fox|michael@future.com|$2y$10$....hashed_here...|admin|2025-12-09 21:48:11
